Let's get Started :
1. Add Plugin to Bubble and Configure Workflows: Once installed, navigate to your application, add it to your app and configure the necessary workflows.
2. Initialize Excel : In your workflow, use the "Initialize Excel Workbook" action. Upload your excel template file or Provide the URL in the designated field.
3. Add Data to Excel Workbook: Use the "Add Data to Excel " action to insert data into specific cells of the Excel workbook. The Fields include :
Cell -Specify the target cell where you want the data to be inserted.
Data-Provide the data you wish to insert.
Direction: Choose the direction in which the data should be inserted (vertical or horizontal).
4. Add Formulas (If Necessary): If your Excel workbook requires formulas, utilize the "Add Formula" action to incorporate them seamlessly. Define the cell where the formula should be applied.Input the formula expression to perform the desired calculation.
5. Add Chart (If Necessary): To visualize data within your Excel workbook, you can add charts such as Bar,Line, Pie, Donut,Polar,radar and Scatter plot. Customize the chart parameters as desired, ensuring clarity and relevance.
6. Generate Excel: Conclude the Excel workbook creation process by choosing to either download the file or save it to your Bubble database for future access.
Download the Excel workbook or alternatively, save the Excel workbook directly to your database for convenient retrieval within your application.
7. Reset Input-Excel: This is clear the data inputs, making the template ready for the next use.
Demo Url:
https://urion-plugins.bubbleapps.io/version-test/ult_excelBy following these steps, you can effortlessly integrate Excel functionality into your Bubble.io application, empowering you to manipulate data, perform calculations, visualize insights, and enhance user experiences with unparalleled ease and efficiency.